Tabela Equipment

Definicja tabeli Equipment

Name

Equipment

Code

Equipment

Comment

PL: Definicja sprzetu medycznego
EN: Medical equipment definition


Lista kolumn tabeli Equipment

Name

Code

EquipmentID

EquipmentID

UnitID

UnitID

Active

Active

StartDT

StartDT

StopDT

StopDT

ConsumptionValue

ConsumptionValue

ConsumptionAlarm

ConsumptionAlarm

ExchangeDT

ExchangeDT


Kolumna EquipmentID tabeli Equipment

Definicja kolumny EquipmentID tabeli Equipment

Name

EquipmentID

Code

EquipmentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli Equipment

Definicja kolumny UnitID tabeli Equipment

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Equipment

Definicja kolumny Active tabeli Equipment

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli Equipment

Definicja kolumny StartDT tabeli Equipment

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Equipment

Definicja kolumny StopDT tabeli Equipment

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna ConsumptionValue tabeli Equipment

Definicja kolumny ConsumptionValue tabeli Equipment

Name

ConsumptionValue

Code

ConsumptionValue

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Kolumna ConsumptionAlarm tabeli Equipment

Definicja kolumny ConsumptionAlarm tabeli Equipment

Name

ConsumptionAlarm

Code

ConsumptionAlarm

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Kolumna ExchangeDT tabeli Equipment

Definicja kolumny ExchangeDT tabeli Equipment

Name

ExchangeDT

Code

ExchangeDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli Equipment

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Equipment

Definicja klucza Identifier_1 tabeli Equipment

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment